===Database campusclubms

== Table structure for table clubs

|------
|Column|Type|Null|Default
|------
|//**clubID**//|int|No|
|clubName|varchar(50)|Yes|NULL
|clubCategory|varchar(30)|Yes|NULL
|foundationDate|date|Yes|NULL
|locationName|varchar(50)|Yes|NULL
== Dumping data for table clubs

|1|AI Innovators|Technology|2018-09-01|Science Block
|3|Music Fusion|Arts|2020-11-10|Auditorium
|5|Karate Dojo|Sports|2015-03-21|Gym Hall
|7|Web Designer Nerds|Technology|2022-02-04|Science Block
|8|Knitting Club|StylistClub|2025-01-01|Lecture Hall 2
|11|Cybersecurity Practice Club|Workshop|2025-01-01|Lecture Hall 102 Main Wing
|12|Healthy Cooking Workshop|Workshop|2025-01-01|Kitchen Lab
|13|Quantum Physic Experiment|Science|2025-05-30|Science Lab
|14|Meditation Club|Health|2024-10-25|Escape Room
== Table structure for table club_memberships

|------
|Column|Type|Null|Default
|------
|//**membershipID**//|int|No|
|studentID|int|Yes|NULL
|clubID|int|Yes|NULL
|membershipDate|date|Yes|NULL
|membershipNo|char(10)|Yes|NULL
== Dumping data for table club_memberships

|4|3|3|2023-09-20|M004
== Table structure for table events

|------
|Column|Type|Null|Default
|------
|//**eventID**//|int|No|
|clubID|int|Yes|NULL
|studentID|int|Yes|NULL
|eventName|varchar(100)|Yes|NULL
|eventType|enum(&#039;Meeting&#039;, &#039;Competition&#039;, &#039;Workshop&#039;, &#039;Promotion&#039;, &#039;Restriction&#039;, &#039;Other&#039;)|Yes|NULL
|eventDate|date|Yes|NULL
|eventTime|time|Yes|NULL
|location|varchar(100)|Yes|NULL
|description|text|Yes|NULL
== Dumping data for table events

|2|8|NULL|Learn knitting for beginners|Workshop|2025-11-29|17:00:00|Lecture Hall 2|anyone who want to learn knitting please join us
== Table structure for table event_participations

|------
|Column|Type|Null|Default
|------
|//**participationID**//|int|No|
|eventID|int|Yes|NULL
|studentID|int|Yes|NULL
|role|enum(&#039;Attendee&#039;, &#039;Organizer&#039;, &#039;Performer&#039;, &#039;Competitor&#039;, &#039;Judge&#039;, &#039;Other&#039;)|Yes|NULL
|notes|text|Yes|NULL
== Dumping data for table event_participations

== Table structure for table students

|------
|Column|Type|Null|Default
|------
|//**studentID**//|int|No|
|firstName|varchar(30)|Yes|NULL
|lastName|varchar(30)|Yes|NULL
|dateOfBirth|date|Yes|NULL
|email|varchar(50)|Yes|NULL
|phoneNumber|varchar(15)|Yes|NULL
== Dumping data for table students

|1|Morgan|Dora|1977-02-04|phd.doramorgan@gmail.com|07777789456
|3|Clara|Smith|2003-01-05|clara.smith@email.com|0733333333
|9|Laura|Mitchell|1985-09-27|laura.mitchell@yahoo.com|07544239876
|65|Michael|Smith|1999-11-23|michael.smith@yahoo.com|07123456702
|67|Daniel|Davis|1998-07-14|daniel.davis@yahoo.com|07123456704
|69|James|Wilson|1997-12-05|james.wilson@yahoo.com|07123456706
|71|Benjamin|Taylor|1999-04-28|benjamin.taylor@yahoo.com|07123456708
|75|Ethan|White|1998-02-07|ethan.white@yahoo.com|07123456712
|76|Amelia|Harris|2002-12-25|amelia.harris@gmail.com|07123456713
|79|Lucas|Garcia|1999-05-21|lucas.garcia@yahoo.com|07123456716
|80|Evelyn|Martinez|2000-07-30|evelyn.martinez@gmail.com|07123456717
|83|Logan|Rodriguez|1998-01-27|logan.rodriguez@yahoo.com|07123456720
|86|Lily|Walker|2000-11-03|lily.walker@gmail.com|07123456723
|87|Jacob|Hall|1997-02-26|jacob.hall@yahoo.com|07123456724
|92|Zoey|Wright|2002-07-19|zoey.wright@gmail.com|07123456729
|97|Levi|Adams|1996-10-17|levi.adams@yahoo.com|07123456734
|98|Chloe|Baker|2002-02-05|chloe.baker@gmail.com|07123456735
|102|Penelope|Mitchell|2001-07-25|penelope.mitchell@gmail.com|07123456739
|105|David|Turner|1996-08-29|david.turner@yahoo.com|07123456742
|106|Madison|Phillips|2001-10-10|madison.phillips@gmail.com|07123456743
